myde_total = $this->numeric($myde_total); $this->myde_size = $this->numeric($myde_size); $this->myde_page = $this->numeric($myde_page); $this->myde_page_count = ceil($this->myde_total / $this->myde_size); $this->myde_url = $myde_url; if ($this->myde_total < 0) $this->myde_total = 0; if ($this->myde_page < 1) $this->myde_page = 1; if ($this->myde_page_count < 1) $this->myde_page_count = 1; if ($this->myde_page > $this->myde_page_count) $this->myde_page = $this->myde_page_count; $this->limit = ($this->myde_page - 1) * $this->myde_size; $this->myde_i = $this->myde_page - $show_pages; $this->myde_en = $this->myde_page + $show_pages; if ($this->myde_i < 1) { $this->myde_en = $this->myde_en + (1 - $this->myde_i); $this->myde_i = 1; } if ($this->myde_en > $this->myde_page_count) { $this->myde_i = $this->myde_i - ($this->myde_en - $this->myde_page_count); $this->myde_en = $this->myde_page_count; } if ($this->myde_i < 1) $this->myde_i = 1; } //检测是否为数字 private function numeric($num) { if (strlen($num)) { if (!preg_match("/^[0-9]+$/", $num)) { $num = 1; } else { $num = substr($num, 0, 11); } } else { $num = 1; } return $num; } //地址替换 private function page_replace($page) { return str_replace("{page}", $page, $this->myde_url); } //首页 private function myde_home() { if ($this->myde_page != 1) { return "首页"; } else { return "首页
"; } } //上一页 private function myde_prev() { if ($this->myde_page != 1) { return "上一页"; } else { return "上一页
"; } } //下一页 private function myde_next() { if ($this->myde_page != $this->myde_page_count) { return "下一页"; } else { return"下一页
"; } } //尾页 private function myde_last() { if ($this->myde_page != $this->myde_page_count) { return "尾页"; } else { return "尾页
"; } } //输出 public function myde_write($id = 'page') { $str = " "; $str.=$this->myde_home(); $str.=$this->myde_prev(); if ($this->myde_i > 1) { $str.=" ...
"; } for ($i = $this->myde_i; $i <= $this->myde_en; $i++) { if ($i == $this->myde_page) { $str.=" $i"; } else { $str.=" $i"; } } if ($this->myde_en < $this->myde_page_count) { $str.=" ...
"; } $str.=$this->myde_next(); $str.=$this->myde_last(); $str.=" 共" . $this->myde_page_count . "页" . $this->myde_total . "条数据
"; $str.=" "; return $str; }}?> 
PHP
include_once("config.php"); require_once('page.class.php'); //分页类 $showrow = 10; //一页显示的行数 $curpage = empty($_GET['page']) ? 1 : $_GET['page']; //当前的页,还应该处理非数字的情况 $url = "?page={page}"; //分页地址，如果有检索条件 ="?page={page}&q=".$_GET['q'] //省略了链接mysql的代码，测试时自行添加 $sql = "SELECT id,content,addtime FROM wishing_wall"; $total = mysql_num_rows(mysql_query($sql)); //记录总条数 if (!empty($_GET['page']) && $total != 0 && $curpage > ceil($total / $showrow)) $curpage = ceil($total_rows / $showrow); //当前页数大于最后页数，取最后一页 //获取数据 $sql .= " LIMIT " . ($curpage - 1) * $showrow . ",$showrow;"; $query = mysql_query($sql); 分页数据显示
显示分页条
$showrow) { //总记录数大于每页显示数，显示分页 $page = new page($total, $showrow, $curpage, $url, 2); echo $page->myde_write(); } ?>
#创建数据库名：democreate table wishing_wall( id INT NOT NULL AUTO_INCREMENT, content VARCHAR(100), addtime timestamp not null default current_timestamp, PRIMARY KEY(id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;